LibreOffice Logo LibreOffice Logo Extensions, Documentation and Templates repository

importcsvtext Import CSV As Text

Tools for CSV files import as text only.

★ ★ ★ ★ ★
Calc
Download latest

latest release: 2024-03-18 05:38:52

Description

Import CSV As Text imports CSV files as text to Calc documents.

-> All columns are in text format.

 

The tools comes as a two-buttons toolbar and can be also found under the Tools > Add-ons menu.

 

The first toolbutton (black) opens a dialogue allowing to define and test the import settings:

  • source directory (default: documents directory),
  • charset (default: UTF-8),
  • start row (default: 1),
  • column separator (default: comma),
  • text delimiter (default: double-quotes),
  • target (new document or new sheet in the current document; default : new document).

These settings are stored between sessions and used by the second toolbutton action. The dialogue also allows to test file imports.

The second toolbutton (white) directly select the CSV file to be imported and uses the settings as defined above.

 

The dialogue is shown in English (as default and fallback language) or in French, depending upon the LibreOffice UI language. Localizing the dialogue and messages is made by simply providing the corresponding PO file.

 

Icons are by Freepik (https://freepik.com).

Release Description Compatibility Operating Systems License Release notes Updated  
Version 0.2.0 First public version. 6.4 Linux, Windows GPL First public version. 2022-10-16 08:32:54 Download

Related Extensions

LibreOffice Linguistic Tools (LOLT)

Screenshot for LibreOffice Linguistic Tools (LOLT)

A menu of tools for linguistic write-ups and other documents written in lesser-known languages.

10-2024

1020

Not rated yet

Multi Book Search

Logo for Multi Book Search

Restart search under the specified folder,Open all Calc files and search for strings.

05-2024

73

Not rated yet

Biorhythm Calculator

Screenshot for Biorhythm Calculator

Calculate Biorhythms

06-2024

449

Not rated yet

Optimal Column Width RI

Logo for Optimal Column Width RI

Optimal Column Width Including Right Indent

05-2024

141

Not rated yet

Bible Search (JP, Eng)

Logo for Bible Search (JP, Eng)

A Japanese and English Bible search tool.You can easily extract strings from multiple lines at once.
JP:New revised translation 2003Eng:King James Version
日本語および英語の聖書検索ツールです。複数行まとめて簡単に文字列を取り出せます。
 

10-2024

174

Not rated yet

Expand Matrix Rows

Logo for Expand Matrix Rows

Change the last row of the matrix by selection.

05-2024

110

Not rated yet

Feedback

★ ★ ★ ★ ★

Post your review

You cannot post reviews until you have logged in. Se connecter.

Reviews

  • Vladyslav Orlov 1 nov. 2022, 10:45 (Il y a 2 année)

    ★ ★ ★ ★ ★

    Solid, high-quality development, which fulfills exactly what is stated in the description. Perhaps it makes sense to think about placing the menu not in the Tools > Add-ons menu, but near the File-Open or Sheet - Insert Sheet from File?

RSS feed for reviews on this page | RSS feed for all reviews