You can easily import & synchronize data from a wide range of data sources into SkyDesk Reports for reporting & analysis. This includes Files, Feeds, Cloud Drives, Local & Cloud databases, NoSQL, Popular Business Applications, Your custom made applications etc..,
Know more about the featured list of data connectors
The screenshot below corresponds to importing data in a CSV file from your local drive.
Type in a name for the database you want to create. Providing description is optional. You can browse & load the file directly from your local drive or copy-paste the data using the Pasted Data option. You can also import data directly from web URL feeds using the 'Web' option.
Check out the help documentation page on how to import data into SkyDesk Reports. Watch demo.
Data is stored in entities called Tables. You should provide a table name for the data imported into SkyDesk Reports.
You can also change the First Row Contains Column Names setting if needed. If the data imported contains any time/date values, SkyDesk Reports will automatically identify the format. You can also set your own date format.
While importing the CSV file, you also have customizing options like modifying the delimiter separating your columns, skipping the top n rows, specifying the comment character etc.
As shown below, SkyDesk Reports automatically takes the values in the first row of the imported file and lists them as column names (Date, Region, Product Category, Product etc. in this case). The first 4 rows from the file are shown as preview.
Import summary of the data imported into SkyDesk Reports.
The screenshot below, shows the data imported into the spreadsheet like interface of SkyDesk Reports.
Connect to Any Data Source
Synchronize your business data scattered in flat files, feeds, databases, cloud storage services and online/offline applications into SkyDesk Reports for analysis & reporting. Data sync is automatic with periodic scheduling. Learn More