# How to import CSV into Clarion 11 TopSpeed file without writing code

**URL:** <https://clarionhub.com/t/how-to-import-csv-into-clarion-11-topspeed-file-without-writing-code/3942>\
**Category:** questions\
**Created:** [March 13, 2021, 11:58pm UTC](https://clarionhub.com/t/how-to-import-csv-into-clarion-11-topspeed-file-without-writing-code/3942 "2021-03-13T23:58:31Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![CarlBarnes](https://clarionhub.com/user_avatar/clarionhub.com/carlbarnes/32/1859_2.png) [@CarlBarnes](https://clarionhub.com/u/CarlBarnes)\
**Post date:** [March 14, 2021, 2:32pm UTC](https://clarionhub.com/t/how-to-import-csv-into-clarion-11-topspeed-file-without-writing-code/3942/7 "2021-03-14T14:32:26Z")

</div>

> [@Waldo](#):
>
> I may be missing something here but I simply need to import or drag and drop a .csv file into my tps file. Is that possible without doing the necessary coding from scratch?

TopScan has an Export to CSV that I often use, I agree it would be very useful if there was also an Import.

My method is not “code free” but it is mostly generated. Define the CSV File in the DCT (see import below). The DCT lets you browse file to see its right. For a 1 time convert use the DCT conversion, or if you’ll be doing this often…

In an APP generate a Process to Read the CSV and Add to the TopSpeed. You’ll have to code those assignments and convert types. To help you can wizard a Browse / Form of the CSV file to view it before import. I made an example

> **[StringTheory-Tools/BasicFileBrowse at master · CarlTBarnes/StringTheory-Tools](https://github.com/CarlTBarnes/StringTheory-Tools/tree/master/BasicFileBrowse)**
>
> StringTheory tools BigBangTheory, Scratch Theory, Split Theory and Write Theory to assist in writing, testing and debugging ST code. Similar Bang String class for non-ST. - CarlTBarnes/StringTheory...

Use the Import Tables in DCT to aid in defining the CSV file.

 ![image](https://clarionhub-uploads.s3.eu-north-1.amazonaws.com/original/2X/4/46233bee512f57d7a73cfa8bcee26fe2553d4c6a.png)

The import does a good job of picking types but you’ll need to review them. If you don’t check “First Header” the field names will be LABEL1,2,3… All the data types will all be STRING and the size will be increased to fit the Header label. E.g. “Benefits Required” is Yes/No so is sized as STRING(3) with Header checked but without STRING(18).

You will want to change the File’s FileName property because it will have the path picked in theimport wizard C:\xxxx\xxx\file.csv.

 ![image](https://clarionhub-uploads.s3.eu-north-1.amazonaws.com/original/2X/d/da8f6ae54aa909695826855a76742d5e0bac51f9.png)

 ![image](https://clarionhub-uploads.s3.eu-north-1.amazonaws.com/original/2X/b/b2c23a04982f2d20337235bb82d2123d29162711.png)

Now you have the CSV File and in an APP you can generate a Process to read it and add code to write your TPS.

If this is just a 1 time conversion you can use the DCT Conversion. Right-click on the TPS file and choose “Generate Conversion Program”, then pick From Table, then Pick the CSV file. It can do a “Code Free” Auto Convert if your column names match.

---

_[View the full topic](https://clarionhub.com/t/how-to-import-csv-into-clarion-11-topspeed-file-without-writing-code/3942)._