Salesforce

Express Labels Mobile - Import Excel Data

« Go Back

Content

 
Article Number000011389
TitleExpress Labels Mobile - Import Excel Data
Body
Import External Data into a Label File Using Express Labels Mobile



You can upload your Excel File to a Cloud Service like Google Drive or One Drive, or save the data file to local mobile device storage using a USB connection. The Express Labels mobile app can open .CSV, .TXT and Excel spreadsheets. 
 
Note: If you email the Excel file, you may need to download that file to the Express Labels Mobile folder. If the file is not visible, it is not in the correct folder.
 
  1. Launch the Express Labels Mobile application.
 
  1. Select a label type under Start a new label. 
Note: If you selected to create a Blank, Flag, Slide, Tube or Vial label, proceed to step 4.
 
ELM Main menu
 
  1. Select the keyboard for the Text Box and select the spreadsheet icon. Proceed to step 6.
Import data option
 
  1. If you selected to create a Blank, Flag, Slide, Tube or Vial label, select Spreadsheet.
Spreadsheet option for Blank
 
  1. If you selected to create a Blank, Flag, Slide, Tube or Vial label, select if you want the imported data to a Text Box or barcode
Text or barcode for imported data
 
  1. Go to your Email application on your phone. If you are using Apple and Android, you will need to save the files in order to access them in Express Labels.
Apple devices - Save the file to the Express Labels folder in the local storage. Follow the steps below:
  1. Email the spreadsheet to an email accessible on the Apple device.
  2. Click and hold the excel file and select Save to Files.
Save to files
  1. Tap in the Search and type Express Labels. Select the Express Labels folder
Search     Express labels
  1. Select Save. The file will now appear in the Local Folder. 
Save     Select data source
 
Android Devices - Files are best transferred using Cloud services. If a file is emailed, follow the steps below to save the file.
 
  1. Open the email with the file.
 
  1. Click the Drive icon.
Email file
  1. Click Save.
Save to Drive_
  1. Open the Drive app.
 
  1. Click the three dots for the file.
three dots
  1. Click Open with.
Open with
  1. The File imported message displays in Express Labels. Click OK.
File Imported
 
  1. Select Storage Cloud services or the local folder where you saved your data file.
Note: You will need to add the file to the local folder. You are not able to browse the local file system (Files > Download).
 
  1. Browse and select an excel file from one of the Cloud Storage options once.
 
  1. After selecting the file from Cloud Storage, it gets copied to the Local folder. The next time you want to import data from the same file, you can select "Local" and the file will be listed there.
 
  1. Select the excel file from "Local" and import data.
 
Import data options

 
  1. Select your .csv, .txt or Excel spreadsheet.
image.png
 
  1. Once your file is loaded, configure your imported text using the menu options at the bottom.
Spreadsheet properties          Spreadsheet properties
 
  • If you have multiple sheets in your spreadsheet, select the corresponding sheet.
  • First row is column header is turned on by default
  • Exclude empty cells is turned on by default
  • If you have data in multiple columns, select the corresponding column.
 
  1. Select the gray portion of the screen to complete the import.
 Spreadsheet_gray area
 
  1. If data does not fit the text box area, choose Autofit. Adjust text and label settings, as applicable, in Text, Paragraph and Object.
Sequence added to label
  
  1. Select the yellow circle with the printer icon to print the labels.
Print.png
 
 
Related information
 
URL NameHow-to-Import-Excel-Data-in-the-Express-Labels-Mobile-App

Powered by