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

try: import

Logo for try: import

Displays the result of trying to "import <Library>" in Python.(Calc Template)

11-2024

90

Not rated yet

PyPi Reader

Screenshot for PyPi Reader

Get release information from RSS in the PyPi-library.(Calc Template)

11-2024

22

Not rated yet

waterfall chart

Screenshot for waterfall chart

this template offers a simple solution for creating chart a waterfall or cascade chart

09-2024

272

Not rated yet

Kalendaro

Logo for Kalendaro

Simple and lightweight calendars

09-2024

1991

Not rated yet

LibrePythonista

Logo for LibrePythonista

LibrePythonista is an extension for LibreOffice Calc. The extension allows Interactive Python code to be run directly in a spreadsheet.

10-2024

1924

★ ★ ★ ★ ☆

Calendrier mensuel

Screenshot for Calendrier mensuel

Feuille de calcul qui génère un calendrier mensuel configurable et imprimable. Exemple d'utilisation de diverses fonctions de recherche, dates et utilisation intensive de formats conditionnels. Paramètres : noms des jours de la semaine et des mois dans

 
 

Not rated yet

Feedback

★ ★ ★ ★ ★

Post your review

You cannot post reviews until you have logged in. Login Here.

Reviews

  • Vladyslav Orlov Nov 1, 2022, 10:45 AM (2 years ago)

    ★ ★ ★ ★ ★

    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